Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	5762
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	720.2 KiB
Average record size in memory	128.0 B

Variable types

Numeric	15

Alerts

`revenue_purc` is highly overall correlated with `volume_products_purc` and 6 other fields	High correlation
`recency_days` is highly overall correlated with `volume_products_purc` and 3 other fields	High correlation
`volume_products_purc` is highly overall correlated with `revenue_purc` and 7 other fields	High correlation
`assort_products_purc` is highly overall correlated with `revenue_purc` and 5 other fields	High correlation
`purchases` is highly overall correlated with `revenue_purc` and 6 other fields	High correlation
`avg_period_purc` is highly overall correlated with `revenue_purc` and 5 other fields	High correlation
`frequency_purc` is highly overall correlated with `recency_days` and 2 other fields	High correlation
`volume_basket_size_purc` is highly overall correlated with `revenue_purc` and 5 other fields	High correlation
`assort_basket_size_purc` is highly overall correlated with `assort_products_purc` and 2 other fields	High correlation
`avg_ticket_purc` is highly overall correlated with `revenue_purc` and 5 other fields	High correlation
`returns` is highly overall correlated with `purchases` and 2 other fields	High correlation
`volume_products_ret` is highly overall correlated with `returns` and 1 other fields	High correlation
`revenue_ret` is highly overall correlated with `returns` and 1 other fields	High correlation
`revenue_real` is highly overall correlated with `revenue_purc` and 6 other fields	High correlation
`revenue_purc` is highly skewed (γ1 = 21.76985821)	Skewed
`volume_products_purc` is highly skewed (γ1 = 23.18016801)	Skewed
`volume_basket_size_purc` is highly skewed (γ1 = 48.78459009)	Skewed
`avg_ticket_purc` is highly skewed (γ1 = 27.95618163)	Skewed
`volume_products_ret` is highly skewed (γ1 = 51.81822874)	Skewed
`revenue_ret` is highly skewed (γ1 = 59.82311707)	Skewed
`revenue_real` is highly skewed (γ1 = 23.87344331)	Skewed
`customer_id` has unique values	Unique
`revenue_purc` has 67 (1.2%) zeros	Zeros
`volume_products_purc` has 67 (1.2%) zeros	Zeros
`assort_products_purc` has 67 (1.2%) zeros	Zeros
`purchases` has 67 (1.2%) zeros	Zeros
`frequency_purc` has 67 (1.2%) zeros	Zeros
`volume_basket_size_purc` has 67 (1.2%) zeros	Zeros
`assort_basket_size_purc` has 67 (1.2%) zeros	Zeros
`avg_ticket_purc` has 67 (1.2%) zeros	Zeros
`returns` has 4190 (72.7%) zeros	Zeros
`volume_products_ret` has 4190 (72.7%) zeros	Zeros
`revenue_ret` has 4190 (72.7%) zeros	Zeros

Reproduction

Analysis started	2023-05-15 20:45:44.467849
Analysis finished	2023-05-15 20:46:41.533147
Duration	57.07 seconds
Software version	ydata-profiling vv4.1.2
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	5762
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16622.832

Minimum	12346
Maximum	22709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	12346
5-th percentile	12701.05
Q1	14298.25
median	16251
Q3	18235.75
95-th percentile	21768.95
Maximum	22709
Range	10363
Interquartile range (IQR)	3937.5

Descriptive statistics

Standard deviation	2817.1868
Coefficient of variation (CV)	0.16947694
Kurtosis	-0.83876473
Mean	16622.832
Median Absolute Deviation (MAD)	1970.5
Skewness	0.43163523
Sum	95780760
Variance	7936541.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
21088	1	< 0.1%
21086	1	< 0.1%
15578	1	< 0.1%
12424	1	< 0.1%
21084	1	< 0.1%
17837	1	< 0.1%
21081	1	< 0.1%
14327	1	< 0.1%
21078	1	< 0.1%
Other values (5752)	5752	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%

Value	Count	Frequency (%)
22709	1	< 0.1%
22708	1	< 0.1%
22707	1	< 0.1%
22706	1	< 0.1%
22705	1	< 0.1%
22704	1	< 0.1%
22700	1	< 0.1%
22699	1	< 0.1%
22696	1	< 0.1%
22695	1	< 0.1%

revenue_purc
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	5450
Distinct (%)	94.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1781.5213

Minimum	0
Maximum	279138.02
Zeros	67
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	8.855
Q1	225.6275
median	602.03
Q3	1554.8475
95-th percentile	5234.605
Maximum	279138.02
Range	279138.02
Interquartile range (IQR)	1329.22

Descriptive statistics

Standard deviation	7839.4074
Coefficient of variation (CV)	4.4004006
Kurtosis	617.23663
Mean	1781.5213
Median Absolute Deviation (MAD)	479.44
Skewness	21.769858
Sum	10265126
Variance	61456308
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	67	1.2%
7.95	9	0.2%
4.95	8	0.1%
2.95	8	0.1%
1.25	8	0.1%
3.75	7	0.1%
12.75	7	0.1%
1.65	7	0.1%
7.5	6	0.1%
4.25	6	0.1%
Other values (5440)	5629	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67	1.2%
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
136275.72	1	< 0.1%
124564.53	1	< 0.1%
116729.63	1	< 0.1%
91062.38	1	< 0.1%
77183.6	1	< 0.1%
72882.09	1	< 0.1%

recency_days
Real number (ℝ)

Distinct	305
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.19872

Minimum	0
Maximum	400
Zeros	38
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	23
median	72
Q3	206
95-th percentile	354
Maximum	400
Range	400
Interquartile range (IQR)	183

Descriptive statistics

Standard deviation	115.0544
Coefficient of variation (CV)	0.9572016
Kurtosis	-0.60870472
Mean	120.19872
Median Absolute Deviation (MAD)	63
Skewness	0.82223292
Sum	692585
Variance	13237.516
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	110	1.9%
4	105	1.8%
3	98	1.7%
2	91	1.6%
10	86	1.5%
8	82	1.4%
9	79	1.4%
17	79	1.4%
7	78	1.4%
15	67	1.2%
Other values (295)	4887	84.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38	0.7%
1	110	1.9%
2	91	1.6%
3	98	1.7%
4	105	1.8%
5	52	0.9%
7	78	1.4%
8	82	1.4%
9	79	1.4%
10	86	1.5%

Value	Count	Frequency (%)
400	67	1.2%
373	23	0.4%
372	22	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	15	0.3%
365	19	0.3%
364	11	0.2%

volume_products_purc
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1844
Distinct (%)	32.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	967.23464

Minimum	0
Maximum	196844
Zeros	67
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	101
median	310
Q3	799
95-th percentile	2905.65
Maximum	196844
Range	196844
Interquartile range (IQR)	698

Descriptive statistics

Standard deviation	4404.1613
Coefficient of variation (CV)	4.5533536
Kurtosis	794.08986
Mean	967.23464
Median Absolute Deviation (MAD)	252
Skewness	23.180168
Sum	5573206
Variance	19396637
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	114	2.0%
2	72	1.2%
0	67	1.2%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	25	0.4%
88	22	0.4%
72	21	0.4%
Other values (1834)	5277	91.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67	1.2%
1	114	2.0%
2	72	1.2%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
7	20	0.3%
8	18	0.3%
9	7	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80179	1	< 0.1%
77373	1	< 0.1%
74215	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%

assort_products_purc
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	437
Distinct (%)	7.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68.844846

Minimum	0
Maximum	1785
Zeros	67
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	13
median	35
Q3	83
95-th percentile	240
Maximum	1785
Range	1785
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	101.39387
Coefficient of variation (CV)	1.4727882
Kurtosis	44.057421
Mean	68.844846
Median Absolute Deviation (MAD)	27
Skewness	4.7120918
Sum	396684
Variance	10280.717
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	279	4.8%
2	148	2.6%
3	114	2.0%
10	101	1.8%
5	99	1.7%
9	96	1.7%
8	92	1.6%
6	92	1.6%
11	92	1.6%
13	91	1.6%
Other values (427)	4558	79.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67	1.2%
1	279	4.8%
2	148	2.6%
3	114	2.0%
4	89	1.5%
5	99	1.7%
6	92	1.6%
7	91	1.6%
8	92	1.6%
9	96	1.7%

Value	Count	Frequency (%)
1785	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
1108	1	< 0.1%
884	1	< 0.1%
816	1	< 0.1%
748	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%

purchases
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	58
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4288442

Minimum	0
Maximum	206
Zeros	67
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	11
Maximum	206
Range	206
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	6.773486
Coefficient of variation (CV)	1.9754429
Kurtosis	303.3001
Mean	3.4288442
Median Absolute Deviation (MAD)	1
Skewness	13.204776
Sum	19757
Variance	45.880112
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2871	49.8%
2	827	14.4%
3	501	8.7%
4	395	6.9%
5	236	4.1%
6	173	3.0%
7	139	2.4%
8	98	1.7%
9	69	1.2%
0	67	1.2%
Other values (48)	386	6.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67	1.2%
1	2871	49.8%
2	827	14.4%
3	501	8.7%
4	395	6.9%
5	236	4.1%
6	173	3.0%
7	139	2.4%
8	98	1.7%
9	69	1.2%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%

avg_period_purc
Real number (ℝ)

Distinct	1155
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	245.48757

Minimum	1
Maximum	400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	1
5-th percentile	20
Q1	61.3125
median	400
Q3	400
95-th percentile	400
Maximum	400
Range	399
Interquartile range (IQR)	338.6875

Descriptive statistics

Standard deviation	166.98758
Coefficient of variation (CV)	0.68022827
Kurtosis	-1.8272988
Mean	245.48757
Median Absolute Deviation (MAD)	0
Skewness	-0.24031186
Sum	1414499.4
Variance	27884.853
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400	2990	51.9%
70	21	0.4%
46	18	0.3%
55	17	0.3%
49	16	0.3%
31	16	0.3%
91	16	0.3%
21	15	0.3%
35	15	0.3%
42	15	0.3%
Other values (1145)	2623	45.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.2%
2	4	0.1%
2.88372093	1	< 0.1%
3	6	0.1%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	4	0.1%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
400	2990	51.9%
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	< 0.1%
356	1	< 0.1%
355	2	< 0.1%
352	1	< 0.1%
351	2	< 0.1%

frequency_purc
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1223
Distinct (%)	21.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.022794603

Minimum	0
Maximum	1
Zeros	67
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0028248588
Q1	0.0054054054
median	0.011764706
Q3	0.023465009
95-th percentile	0.068181818
Maximum	1
Range	1
Interquartile range (IQR)	0.018059603

Descriptive statistics

Standard deviation	0.048059033
Coefficient of variation (CV)	2.1083514
Kurtosis	174.74357
Mean	0.022794603
Median Absolute Deviation (MAD)	0.0075093867
Skewness	10.833933
Sum	131.3425
Variance	0.0023096707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	67	1.2%
0.01851851852	37	0.6%
0.005405405405	32	0.6%
0.01639344262	31	0.5%
0.002824858757	30	0.5%
0.004672897196	30	0.5%
0.01538461538	29	0.5%
0.05263157895	29	0.5%
0.01923076923	28	0.5%
0.025	27	0.5%
Other values (1213)	5422	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67	1.2%
0.002673796791	22	0.4%
0.002680965147	21	0.4%
0.002688172043	17	0.3%
0.002702702703	3	0.1%
0.0027100271	13	0.2%
0.002717391304	16	0.3%
0.00272479564	14	0.2%
0.002732240437	19	0.3%
0.002739726027	11	0.2%

Value	Count	Frequency (%)
1	5	0.1%
0.550802139	1	< 0.1%
0.5294117647	1	< 0.1%
0.5	11	0.2%
0.4	1	< 0.1%
0.3333333333	6	0.1%
0.3315508021	1	< 0.1%
0.3157894737	1	< 0.1%
0.2727272727	2	< 0.1%
0.2621621622	1	< 0.1%

volume_basket_size_purc
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	2367
Distinct (%)	41.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	265.16374

Minimum	0
Maximum	74215
Zeros	67
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	72.541667
median	149.33333
Q3	288
95-th percentile	732
Maximum	74215
Range	74215
Interquartile range (IQR)	215.45833

Descriptive statistics

Standard deviation	1192.5611
Coefficient of variation (CV)	4.4974515
Kurtosis	2798.1125
Mean	265.16374
Median Absolute Deviation (MAD)	97.25
Skewness	48.78459
Sum	1527873.5
Variance	1422201.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	115	2.0%
2	71	1.2%
0	67	1.2%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	26	0.5%
100	22	0.4%
72	22	0.4%
Other values (2357)	5275	91.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67	1.2%
1	115	2.0%
2	71	1.2%
3	51	0.9%
3.333333333	1	< 0.1%
4	49	0.9%
5	35	0.6%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6	29	0.5%

Value	Count	Frequency (%)
74215	1	< 0.1%
40498.5	1	< 0.1%
14149	1	< 0.1%
13956	1	< 0.1%
7824	1	< 0.1%
6009.333333	1	< 0.1%
5963	1	< 0.1%
5196	1	< 0.1%
4300	1	< 0.1%
4282	1	< 0.1%

assort_basket_size_purc
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1179
Distinct (%)	20.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.817243

Minimum	0
Maximum	1108
Zeros	67
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	7
median	15
Q3	30.666667
95-th percentile	172
Maximum	1108
Range	1108
Interquartile range (IQR)	23.666667

Descriptive statistics

Standard deviation	76.518212
Coefficient of variation (CV)	2.0783254
Kurtosis	33.222841
Mean	36.817243
Median Absolute Deviation (MAD)	10
Skewness	5.0981723
Sum	212140.96
Variance	5855.0368
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	278	4.8%
2	160	2.8%
3	115	2.0%
9	106	1.8%
10	105	1.8%
7	103	1.8%
5	102	1.8%
8	102	1.8%
6	101	1.8%
13	99	1.7%
Other values (1169)	4491	77.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67	1.2%
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	7	0.1%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.2%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%

Value	Count	Frequency (%)
1108	1	< 0.1%
748	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%
703	1	< 0.1%
686	1	< 0.1%
674	1	< 0.1%
673	1	< 0.1%
660	1	< 0.1%
649	1	< 0.1%

avg_ticket_purc
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	5455
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	575.05808

Minimum	0
Maximum	84236.25
Zeros	67
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	8.855
Q1	155.2725
median	292.11937
Q3	481.625
95-th percentile	1830.902
Maximum	84236.25
Range	84236.25
Interquartile range (IQR)	326.3525

Descriptive statistics

Standard deviation	2029.7879
Coefficient of variation (CV)	3.5297093
Kurtosis	998.0428
Mean	575.05808
Median Absolute Deviation (MAD)	152.29625
Skewness	27.956182
Sum	3313484.7
Variance	4120038.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	67	1.2%
7.95	9	0.2%
2.95	8	0.1%
1.25	8	0.1%
4.95	8	0.1%
1.65	7	0.1%
12.75	7	0.1%
3.75	7	0.1%
4.25	6	0.1%
5.95	6	0.1%
Other values (5445)	5629	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67	1.2%
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%

Value	Count	Frequency (%)
84236.25	1	< 0.1%
77183.6	1	< 0.1%
52940.94	1	< 0.1%
50653.91	1	< 0.1%
21389.6	1	< 0.1%
18745.86	1	< 0.1%
14844.76667	1	< 0.1%
14838.86	1	< 0.1%
13305.5	1	< 0.1%
12681.58	1	< 0.1%

returns
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.59371746

Minimum	0
Maximum	45
Zeros	4190
Zeros (%)	72.7%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	45
Range	45
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.7411912
Coefficient of variation (CV)	2.9326932
Kurtosis	192.19013
Mean	0.59371746
Median Absolute Deviation (MAD)	0
Skewness	10.302776
Sum	3421
Variance	3.0317467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	4190	72.7%
1	914	15.9%
2	292	5.1%
3	140	2.4%
4	92	1.6%
5	37	0.6%
6	32	0.6%
7	21	0.4%
9	8	0.1%
11	5	0.1%
Other values (13)	31	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4190	72.7%
1	914	15.9%
2	292	5.1%
3	140	2.4%
4	92	1.6%
5	37	0.6%
6	32	0.6%
7	21	0.4%
8	5	0.1%
9	8	0.1%

Value	Count	Frequency (%)
45	1	< 0.1%
44	1	< 0.1%
35	1	< 0.1%
27	1	< 0.1%
21	1	< 0.1%
18	2	< 0.1%
17	1	< 0.1%
15	2	< 0.1%
14	1	< 0.1%
13	5	0.1%

volume_products_ret
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	222
Distinct (%)	3.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.210691

Minimum	0
Maximum	80995
Zeros	4190
Zeros (%)	72.7%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	40
Maximum	80995
Range	80995
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1466.2339
Coefficient of variation (CV)	31.057243
Kurtosis	2749.5552
Mean	47.210691
Median Absolute Deviation (MAD)	0
Skewness	51.818229
Sum	272028
Variance	2149841.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4190	72.7%
1	192	3.3%
2	157	2.7%
3	106	1.8%
4	93	1.6%
6	80	1.4%
5	64	1.1%
12	56	1.0%
8	44	0.8%
7	44	0.8%
Other values (212)	736	12.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4190	72.7%
1	192	3.3%
2	157	2.7%
3	106	1.8%
4	93	1.6%
5	64	1.1%
6	80	1.4%
7	44	0.8%
8	44	0.8%
9	42	0.7%

Value	Count	Frequency (%)
80995	1	< 0.1%
74215	1	< 0.1%
9360	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3331	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%

revenue_ret
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1121
Distinct (%)	19.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.081513

Minimum	0
Maximum	168469.6
Zeros	4190
Zeros (%)	72.7%
Negative	0
Negative (%)	0.0%
Memory size	90.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4.95
95-th percentile	114.9965
Maximum	168469.6
Range	168469.6
Interquartile range (IQR)	4.95

Descriptive statistics

Standard deviation	2479.1566
Coefficient of variation (CV)	29.840051
Kurtosis	3859.0771
Mean	83.081513
Median Absolute Deviation (MAD)	0
Skewness	59.823117
Sum	478715.68
Variance	6146217.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4190	72.7%
12.75	21	0.4%
4.95	20	0.3%
15	19	0.3%
9.95	17	0.3%
5.9	13	0.2%
25.5	11	0.2%
3.75	10	0.2%
4.25	10	0.2%
7.5	9	0.2%
Other values (1111)	1442	25.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4190	72.7%
0.42	2	< 0.1%
0.65	1	< 0.1%
0.95	1	< 0.1%
1.25	6	0.1%
1.45	4	0.1%
1.64	1	< 0.1%
1.65	5	0.1%
1.7	2	< 0.1%
1.79	1	< 0.1%

Value	Count	Frequency (%)
168469.6	1	< 0.1%
77183.6	1	< 0.1%
22998.4	1	< 0.1%
14688.24	1	< 0.1%
8511.15	1	< 0.1%
7393.59	1	< 0.1%
5228.4	1	< 0.1%
4815.26	1	< 0.1%
4814.74	1	< 0.1%
4486.24	1	< 0.1%

revenue_real
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5510
Distinct (%)	95.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1698.4398

Minimum	-1208.04
Maximum	278778.02
Zeros	10
Zeros (%)	0.2%
Negative	69
Negative (%)	1.2%
Memory size	90.0 KiB

Quantile statistics

Minimum	-1208.04
5-th percentile	8.2525
Q1	218.6975
median	593.875
Q3	1533.5025
95-th percentile	5150.0125
Maximum	278778.02
Range	279986.06
Interquartile range (IQR)	1314.805

Descriptive statistics

Standard deviation	7311.1671
Coefficient of variation (CV)	4.3046373
Kurtosis	751.13488
Mean	1698.4398
Median Absolute Deviation (MAD)	474.415
Skewness	23.873443
Sum	9786409.9
Variance	53453164
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10	0.2%
7.95	9	0.2%
2.95	8	0.1%
1.25	8	0.1%
4.95	8	0.1%
12.75	7	0.1%
3.75	7	0.1%
1.65	7	0.1%
4.25	6	0.1%
5.95	6	0.1%
Other values (5500)	5686	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1208.04	1	< 0.1%
-1192.2	1	< 0.1%
-1081.14	1	< 0.1%
-811.86	1	< 0.1%
-572	1	< 0.1%
-464.9	1	< 0.1%
-313.86	1	< 0.1%
-295.09	1	< 0.1%
-288	1	< 0.1%
-227.44	1	< 0.1%

Value	Count	Frequency (%)
278778.02	1	< 0.1%
259657.3	1	< 0.1%
189735.53	1	< 0.1%
128882.13	1	< 0.1%
123638.18	1	< 0.1%
113855.32	1	< 0.1%
88138.2	1	< 0.1%
65920.12	1	< 0.1%
62924.1	1	< 0.1%
59419.34	1	< 0.1%

Auto

Heatmap
Table

	customer_id	revenue_purc	recency_days	volume_products_purc	assort_products_purc	purchases	avg_period_purc	frequency_purc	volume_basket_size_purc	assort_basket_size_purc	avg_ticket_purc	returns	volume_products_ret	revenue_ret	revenue_real
customer_id	1.000	-0.189	0.251	-0.296	-0.029	-0.386	0.383	-0.221	-0.155	0.119	-0.051	-0.259	-0.261	-0.259	-0.181
revenue_purc	-0.189	1.000	-0.446	0.932	0.801	0.657	-0.576	0.423	0.732	0.391	0.773	0.400	0.391	0.391	0.994
recency_days	0.251	-0.446	1.000	-0.514	-0.349	-0.611	0.548	-0.876	-0.226	0.014	-0.117	-0.293	-0.281	-0.280	-0.445
volume_products_purc	-0.296	0.932	-0.514	1.000	0.743	0.705	-0.628	0.490	0.797	0.322	0.663	0.419	0.414	0.408	0.926
assort_products_purc	-0.029	0.801	-0.349	0.743	1.000	0.470	-0.393	0.316	0.631	0.742	0.652	0.244	0.232	0.231	0.806
purchases	-0.386	0.657	-0.611	0.705	0.470	1.000	-0.921	0.562	0.188	-0.136	0.111	0.504	0.489	0.489	0.654
avg_period_purc	0.383	-0.576	0.548	-0.628	-0.393	-0.921	1.000	-0.570	-0.157	0.157	-0.079	-0.465	-0.453	-0.453	-0.572
frequency_purc	-0.221	0.423	-0.876	0.490	0.316	0.562	-0.570	1.000	0.222	-0.035	0.112	0.284	0.272	0.272	0.422
volume_basket_size_purc	-0.155	0.732	-0.226	0.797	0.631	0.188	-0.157	0.222	1.000	0.585	0.859	0.141	0.147	0.139	0.728
assort_basket_size_purc	0.119	0.391	0.014	0.322	0.742	-0.136	0.157	-0.035	0.585	1.000	0.653	-0.127	-0.129	-0.130	0.399
avg_ticket_purc	-0.051	0.773	-0.117	0.663	0.652	0.111	-0.079	0.112	0.859	0.653	1.000	0.120	0.122	0.122	0.770
returns	-0.259	0.400	-0.293	0.419	0.244	0.504	-0.465	0.284	0.141	-0.127	0.120	1.000	0.985	0.987	0.376
volume_products_ret	-0.261	0.391	-0.281	0.414	0.232	0.489	-0.453	0.272	0.147	-0.129	0.122	0.985	1.000	0.994	0.363
revenue_ret	-0.259	0.391	-0.280	0.408	0.231	0.489	-0.453	0.272	0.139	-0.130	0.122	0.987	0.994	1.000	0.362
revenue_real	-0.181	0.994	-0.445	0.926	0.806	0.654	-0.572	0.422	0.728	0.399	0.770	0.376	0.363	0.362	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	revenue_purc	recency_days	volume_products_purc	assort_products_purc	purchases	avg_period_purc	frequency_purc	volume_basket_size_purc	assort_basket_size_purc	avg_ticket_purc	returns	volume_products_ret	revenue_ret	revenue_real
0	17850	5391.210	372.000	1733.000	21.000	34.000	1.000	0.091	50.971	0.618	158.565	1.000	40.000	102.580	5288.630
1	13047	3232.590	56.000	1390.000	105.000	9.000	52.833	0.024	154.444	11.667	359.177	7.000	35.000	143.490	3089.100
2	12583	6705.380	2.000	5028.000	114.000	15.000	26.500	0.040	335.200	7.600	447.025	2.000	50.000	76.040	6629.340
3	13748	948.250	95.000	439.000	24.000	5.000	92.667	0.013	87.800	4.800	189.650	0.000	0.000	0.000	948.250
4	15100	876.000	333.000	80.000	1.000	3.000	20.000	0.008	26.667	0.333	292.000	3.000	22.000	240.900	635.100
5	15291	4623.300	25.000	2102.000	61.000	14.000	26.769	0.037	150.143	4.357	330.236	5.000	29.000	71.790	4551.510
6	14688	5630.870	7.000	3621.000	148.000	21.000	19.263	0.056	172.429	7.048	268.137	6.000	399.000	523.490	5107.380
7	17809	5411.910	16.000	2057.000	46.000	12.000	39.667	0.032	171.417	3.833	450.993	2.000	41.000	67.060	5344.850
8	15311	60767.900	0.000	38194.000	567.000	91.000	4.191	0.243	419.714	6.231	667.779	27.000	474.000	1348.560	59419.340
9	16098	2005.630	87.000	613.000	34.000	7.000	47.667	0.019	87.571	4.857	286.519	0.000	0.000	0.000	2005.630

	customer_id	revenue_purc	recency_days	volume_products_purc	assort_products_purc	purchases	avg_period_purc	frequency_purc	volume_basket_size_purc	assort_basket_size_purc	avg_ticket_purc	revenue_real
5752	22700	4839.420	1.000	1074.000	55.000	1.000	400.000	0.500	1074.000	55.000	4839.420	4839.420
5753	13298	360.000	1.000	96.000	2.000	1.000	400.000	0.500	96.000	2.000	360.000	360.000
5754	14569	227.390	1.000	79.000	10.000	1.000	400.000	0.500	79.000	10.000	227.390	227.390
5755	22704	17.900	1.000	14.000	7.000	1.000	400.000	0.500	14.000	7.000	17.900	17.900
5756	22705	3.350	1.000	2.000	2.000	1.000	400.000	0.500	2.000	2.000	3.350	3.350
5757	22706	5699.000	1.000	1747.000	634.000	1.000	400.000	0.500	1747.000	634.000	5699.000	5699.000
5758	22707	6756.060	0.000	2010.000	730.000	1.000	400.000	1.000	2010.000	730.000	6756.060	6756.060
5759	22708	3217.200	0.000	654.000	56.000	1.000	400.000	1.000	654.000	56.000	3217.200	3217.200
5760	22709	3950.720	0.000	731.000	217.000	1.000	400.000	1.000	731.000	217.000	3950.720	3950.720
5761	12713	794.550	0.000	505.000	37.000	1.000	400.000	1.000	505.000	37.000	794.550	794.550

Overview

Variables

Interactions

Correlations

Missing values

Sample